In SQL (Structured Query Language), Data Manipulation Language (DML) is a subset of SQL statements used to manipulate data in a database. DML commands are used to add, modify, delete, and retrieve data from a database table.
The most common DML commands in SQL are:
SELECT - used to retrieve data from a table.
INSERT - used to insert new data into a table.
UPDATE - used to modify existing data in a table.
DELETE - used to delete data from a table.
Here's a brief explanation of each DML command:
SELECT: The SELECT command is used to retrieve data from a table. It allows you to specify which columns to retrieve, which rows to retrieve, and how to sort the data.
INSERT: The INSERT command is used to add new data to a table. It allows you to specify which columns to insert data into and what values to insert.
UPDATE: The UPDATE command is used to modify existing data in a table. It allows you to specify which columns to update, which rows to update, and what values to use.
DELETE: The DELETE command is used to remove data from a table. It allows you to specify which rows to delete based on certain conditions.
In summary, DML commands are used to manipulate data in a database table. They allow you to add, modify, delete, and retrieve data from a table.
Aryan Kumar
28-Apr-2023In SQL (Structured Query Language), Data Manipulation Language (DML) is a subset of SQL statements used to manipulate data in a database. DML commands are used to add, modify, delete, and retrieve data from a database table.
The most common DML commands in SQL are:
Here's a brief explanation of each DML command:
In summary, DML commands are used to manipulate data in a database table. They allow you to add, modify, delete, and retrieve data from a table.
Sumit Kesarwani
22-Sep-2014This language that enable user to access or manipulate data as organised by appropriate data model.
Procedural DML or Low level: DML requires a user to specify what data are needed and how to get those data.
Non-Procedural DML or High level: DML requires a user to specify what data are needed without specifying how to get those data.